

ALTER TABLE  `app_device_info`
    ADD COLUMN `deviceId_type` varchar(20) NULL COMMENT '生成新设备指纹newFingerprint的依据字段, 1:imei; 2:android; 3:gaid; 4:mac; 5:uuid' AFTER `new_fingerprint`;


/*
 Navicat Premium Data Transfer

 Source Server         : 开发数据库
 Source Server Type    : MySQL
 Source Server Version : 50734
 Source Host           : 47.119.190.105:3306
 Source Schema         : pdl_dev

 Target Server Type    : MySQL
 Target Server Version : 50734
 File Encoding         : 65001

 Date: 22/12/2021 14:01:23
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for app_device_fingerprint
-- ----------------------------
DROP TABLE IF EXISTS `app_device_fingerprint`;
CREATE TABLE `app_device_fingerprint` (
                                          `id` int(11) NOT NULL AUTO_INCREMENT,
                                          `user_id` varchar(50) DEFAULT NULL COMMENT '用户id',
                                          `new_fingerprint` varchar(200) DEFAULT NULL COMMENT '新设备指纹',
                                          `action_type` varchar(50) DEFAULT NULL COMMENT '操作类型',
                                          `imei` varchar(50) DEFAULT NULL,
                                          `imei_fingerprint` varchar(120) DEFAULT NULL,
                                          `gaid` varchar(50) DEFAULT NULL,
                                          `gaid_fingerprint` varchar(120) DEFAULT NULL,
                                          `uuid` varchar(50) DEFAULT NULL,
                                          `uuid_fingerprint` varchar(120) DEFAULT NULL,
                                          `android_id` varchar(50) DEFAULT NULL COMMENT '安卓id对应fingerprint',
                                          `android_fingerprint` varchar(255) DEFAULT NULL,
                                          `mac` varchar(50) DEFAULT NULL,
                                          `mac_fingerprint` varchar(120) DEFAULT NULL,
                                          `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                          PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=710609 DEFAULT CHARSET=utf8mb4 COMMENT='设备指纹关联表';

SET FOREIGN_KEY_CHECKS = 1;


/*
 Navicat Premium Data Transfer

 Source Server         : 开发数据库
 Source Server Type    : MySQL
 Source Server Version : 50734
 Source Host           : 47.119.190.105:3306
 Source Schema         : pdl_dev

 Target Server Type    : MySQL
 Target Server Version : 50734
 File Encoding         : 65001

 Date: 28/12/2021 12:20:39
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for app_device_mapper
-- ----------------------------
DROP TABLE IF EXISTS `app_device_mapper`;
CREATE TABLE `app_device_mapper` (
                                     `id` int(11) NOT NULL AUTO_INCREMENT COMMENT ' ',
                                     `phone_brand` varchar(60) DEFAULT NULL COMMENT '手机品牌',
                                     `mapper_brand` varchar(60) DEFAULT NULL COMMENT '映射品牌',
                                     PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of app_device_mapper
-- ----------------------------
BEGIN;
INSERT INTO `app_device_mapper` VALUES (1, 'HXY', 'umidigi');
INSERT INTO `app_device_mapper` VALUES (2, 'Yulong', 'coolpad');
INSERT INTO `app_device_mapper` VALUES (3, 'nokia', 'HMD Global');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;

